package net.sddfp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.sddfp.entity.Goods;
import net.sddfp.model.dto.GoodsDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface GoodsMapper extends BaseMapper<Goods> {

    @Select("SELECT g.*,d.description FROM goods g, goods_detail d WHERE g.goods_id=d.goods_id")
    List<GoodsDTO> queryGoodsDetail();
}
